package com.bbx.taxi.client.DB.Util;

/**
 * 
 * @author yanxuwen
 */
public interface DBcolumns {	
	/**
	 * 地址
	 */
	public  final String TABLE_ADDRESS= "table_address";
	public  final String ADDRESS_ID = "address_id";	
	public  final String ADDRESS_NAME = "address_name";
	public  final String ADDRESS_ADDRESS = "address_address";	
	public  final String ADDRESS_LONGITUDE = "address_longitude";	
	public  final String ADDRESS_LATITUDE = "address_latitude";	
	public  final String ADDRESS_CITY = "address_city";	
	public  final String ADDRESS_COLLECTION = "address_collection";	//值为0则没有收藏，1为收藏
	/**
	 * 常用联系人
	 */
	public  final String TABLE_CONTACTS ="table_contacts";
	public  final String CONTACTS_ID = "contacts_id";	
	public  final String CONTACTS_NAME = "contacts_name";	
	public  final String CONTACTS_TEL = "contacts_tel";	
	public  final String CONTACTS_COLLECTION = "contacts_collection";	//值为0则没有收藏，1为收藏
	/**
	 * 消息
	 */
	public  final String TABLE_MESSAGE ="table_message";
	public  final String MESSAGE_ID = "_id";	
	public  final String MESSAGE_ORDER_ID = "order_id";	
	public  final String MESSAGE_TIME = "time";	
	public  final String MESSAGE_TYPE = "type";	
	public  final String MESSAGE_JSON = "json";	
	public  final String MESSAGE_READ = "is_read";//是否可读，1为已读	
	/**
	 *优惠劵
	 */
	public  final String TABLE_COUPON ="table_coupon";
	public  final String COUPON_id = "_id";	
	public  final String COUPON_ID = "coupon_id";	
	public  final String COUPON_SUM = "coupon_sum";	//金额
	public  final String COUPON_EXPIRE_TIME = "coupon_expire_time";	//到期时间
	public  final String COUPON_USABLETIME = "coupon_usabletime";	
	public  final String COUPON_USABLETYPE = "coupon_usabletype";	
	public  final String COUPON_USABLEORDER = "coupon_usableorder";	
	public  final String COUPON_USABLELINE = "coupon_usableline";	
	/**
	 *推荐列表
	 */
	public  final String TABLE_RECOMMEN ="table_recommen";
	public  final String RECOMMEN_id = "_id";	
	public  final String RECOMMEN_PHONE = "recommen_phone";	
	public  final String RECOMMEN_NANE = "recommen_name";	
	public  final String RECOMMEN_STATE = "recommen_state";
	public  final String RECOMMEN_HEADIMG = "recommen_headimg";	
	/**
	 *我的订单
	 */
	public  final String TABLE_MYORDER ="table_myorder";
	public  final String MYORDER_id = "_id";	
	public  final String MYORDER_ID = "myorder_id";	
	public  final String MYORDER_ORDER_ID = "order_id";
	public  final String MYORDER_PASSENGER_ID="passenger_id";
	public  final String MYORDER_TC_ID="tc_id";
	public  final String MYORDER_TC_NAME="tc_name";
	public  final String MYORDER_ROUND_TRIP = "round_trip";	
	public  final String MYORDER_VEHICLE_ID = "vehicle_type_id";
	public  final String MYORDER_CAR_SEATS = "car_seats";
	public  final String MYORDER_ORDER_TYPE = "order_type";
	public  final String MYORDER_ORDER_TIME = "order_time";	
	public  final String MYORDER_XIADAN_TIME = "xiadan_time";	
	public  final String MYORDER_LINE_ID = "line_id";	
	public  final String MYORDER_TRAVEL_TYPE = "travel_type";	
	public  final String MYORDER_COUPON_ID = "coupon_id";
	public  final String MYORDER_ORDER_STATUS = "order_status";	
	public  final String MYORDER_AUDIT_STATUS = "audit_status";	
	public  final String MYORDER_VALUATE_STATUS = "valuate_status";
	public  final String MYORDER_DRIVER_ID = "driver_id";
	public  final String MYORDER_DRIVER_NAME = "driver_name";
	public  final String MYORDER_CAR_NO = "car_No";
	public  final String MYORDER_DRIVER_PHONE = "driver_phone";
	public  final String MYORDER_DRIVER_STAR	 = "driver_star";
	public  final String MYORDER_DRIVER_MESSAGE	 = "driver_message";
	public  final String MYORDER_PRICE	 = "price";
	public  final String MYORDER_TOTALPRICE	 = "myorder_total_price";
	public  final String MYORDER_ACTUALPRICE	 = "actual_price";
	public  final String MYORDER_COUPONSUM	 = "coupon_sum";
	public  final String MYORDER_SUGGEST	 = "suggest";
	public  final String MYORDER_PURPOSE = "purpose";
	public  final String MYORDER_REJECT_REASON = "reject_reason";
	public  final String MYORDER_VTYPE = "vtype";
	public  final String MYORDER_PAIDAN_VTYPE = "paidan_vtype";
	public  final String MYORDER_OWN= "own_expense";
	public  final String MYORDER_PAY_STATUS= "pay_status";
	public  final String MYORDER_APPOINT_TYPE= "appoint_type";
	/**
	 *进行中订单
	 */
	public  final String TABLE_MYORDERING ="table_myordering";
	public  final String MYORDERING_id = "_id";	
	public  final String MYORDERING_ID = "myorder_id";	
	public  final String MYORDERING_ORDER_ID = "order_id";
	public  final String MYORDERING_PASSENGER_ID="passenger_id";
	public  final String MYORDERING_TC_ID="tc_id";
	public  final String MYORDERING_TC_NAME="tc_name";
	public  final String MYORDERING_ROUND_TRIP = "round_trip";	
	public  final String MYORDERING_VEHICLE_ID = "vehicle_type_id";
	public  final String MYORDERING_CAR_SEATS = "car_seats";
	public  final String MYORDERING_ORDER_TYPE = "order_type";
	public  final String MYORDERING_ORDER_TIME = "order_time";	
	public  final String MYORDERING_XIADAN_TIME = "xiadan_time";	
	public  final String MYORDERING_LINE_ID = "line_id";	
	public  final String MYORDERING_TRAVEL_TYPE = "travel_type";	
	public  final String MYORDERING_COUPON_ID = "coupon_id";
	public  final String MYORDERING_ORDER_STATUS = "order_status";	
	public  final String MYORDERING_AUDIT_STATUS = "audit_status";	
	public  final String MYORDERING_VALUATE_STATUS = "valuate_status";
	public  final String MYORDERING_DRIVER_ID = "driver_id";
	public  final String MYORDERING_DRIVER_NAME = "driver_name";
	public  final String MYORDERING_CAR_NO = "car_No";
	public  final String MYORDERING_DRIVER_PHONE = "driver_phone";
	public  final String MYORDERING_DRIVER_STAR	 = "driver_star";
	public  final String MYORDERING_DRIVER_MESSAGE	 = "driver_message";
	public  final String MYORDERING_PRICE	 = "price";
	public  final String MYORDERING_TOTALPRICE	 = "myorder_total_price";
	public  final String MYORDERING_ACTUALPRICE	 = "actual_price";
	public  final String MYORDERING_COUPONSUM	 = "coupon_sum";
	public  final String MYORDERING_SUGGEST	 = "suggest";
	public  final String MYORDERING_PURPOSE = "purpose";
	public  final String MYORDERING_REJECT_REASON = "reject_reason";
	public  final String MYORDERING_VTYPE = "vtype";
	public  final String MYORDERING_PAIDAN_VTYPE = "paidan_vtype";
	public  final String MYORDERING_OWN= "own_expense";
	public  final String MYORDERING_PAY_STATUS= "pay_status";
	public  final String MYORDERING_APPOINT_TYPE= "appoint_type";
	
	
    /**
     * 未审核订单
     * 
     */
	public  final String TABLE_UNPROCESSED ="table_unprocessed";
	public  final String UNPROCESSED_id = "_id";	
	public  final String UNPROCESSED_ORDER_ID = "order_id";	
	public  final String UNPROCESSED_PASSENGER_ID = "passenger_id";	
	public  final String UNPROCESSED_PURPOSE = "purpose";	
	public  final String UNPROCESSED_ROUND_TRIP = "round_trip";	
	public  final String UNPROCESSED_VEHICLE_ID = "vehicle_type_id";	
	public  final String UNPROCESSED_DRIVER_ID = "driver_id";	
	public  final String UNPROCESSED_DRIVER_NAME = "driver_name";
	public  final String UNPROCESSED_PRICE = "estimate_cost";
	public  final String UNPROCESSED_APPOINT_TIME = "appoint_time";
	 /**
     * 审核记录
     * 
     */
	public  final String TABLE_UNPROCESSED_RECORD ="table_unprocessed_record";
	public  final String UNPROCESSED_RECORD_id = "_id";	
	public  final String UNPROCESSED_RECORD_ORDER_ID = "order_id";	
	public  final String UNPROCESSED_RECORD_PASSENGER_ID = "passenger_id";	
	public  final String UNPROCESSED_RECORD_PURPOSE = "purpose";	
	public  final String UNPROCESSED_RECORD_ROUND_TRIP = "round_trip";	
	public  final String UNPROCESSED_RECORD_VEHICLE_ID = "vehicle_type_id";	
	public  final String UNPROCESSED_RECORD_DRIVER_ID = "driver_id";	
	public  final String UNPROCESSED_RECORD_DRIVER_NAME = "driver_name";
	public  final String UNPROCESSED_RECORD_PRICE = "estimate_cost";
	public  final String UNPROCESSED_RECORD_APPOINT_TIME = "appoint_time";
	public  final String UNPROCESSED_RECORD_PASS_STATUS = "pass_status";//1为通过，0为拒绝
	/**
	 *我的订单的locations表，注意该表是根据我的订单的，因为一个订单有可能存在多个locations值，虽然目前就一个，后期可能多个，所以要在单独在建一个表，
	 *根据我的订单id（order_id）查找locations的内容
	 */
	public  final String TABLE_MYORDER_LOCATIONS ="table_myorder_locations";
	public  final String MYORDER_LOCATIONS_id = "_id";	
	public  final String MYORDER_LOCATIONS_ORDER_ID = "myorder_locations_order_id";//根据该字段可以查找你相应的订单的locations
	public  final String MYORDER_LOCATIONS_START_ADDRESS = "myorder_locations_start_address";	
	public  final String MYORDER_LOCATIONS_START_LNG = "myorder_locations_start_lng";	
	public  final String MYORDER_LOCATIONS_START_LAT = "myorder_locations_start_lat";	
	public  final String MYORDER_LOCATIONS_START_NAME = "myorder_locations_start_name";	
	public  final String MYORDER_LOCATIONS_START_PHONE = "myorder_locations_start_phone";
	public  final String MYORDER_LOCATIONS_END_ADDRESS = "myorder_locations_end_address";	
	public  final String MYORDER_LOCATIONS_END_LNG = "myorder_locations_end_lng";	
	public  final String MYORDER_LOCATIONS_END_LAT = "myorder_locations_end_lat";	
	public  final String MYORDER_LOCATIONS_END_NAME = "myorder_locations_end_name";	
	public  final String MYORDER_LOCATIONS_END_PHONE = "myorder_locations_end_phone";
	public  final String MYORDER_LOCATIONS_VOLUME = "myorder_locations_volume";
	public  final String MYORDER_LOCATIONS_WEIGHT = "myorder_locations_weight";
	public  final String MYORDER_LOCATIONS_COUNT = "myorder_locations_count";
	public  final String MYORDER_MUTIPLE_ONCAR = "mutiple_oncar";
	public  final String MYORDER_START_NEED_SMS = "start_need_sms";
	public  final String MYORDER_END_NEED_SMS = "end_need_sms";
	/**取消订单*/
	public final String TABLE_ORDER_CANCEL="table_cancel";
	public  final String CENCEL_ID = "_id";	
	public  final String CENCEL_ORDER_ID = "order_id";
	public  final String CANCEL_REASON	 = "cancel_reason";//订单q
	
	/**线路*/
	public final String TABLE_LINE="table_line";
	public  final String LINE_ID = "_id";	
	public  final String LINE_NAME = "_name";	
	public  final String LINE_CN_NAME = "cn_name";
	public  final String LINE_JSON = "json";
	/**市内线路*/
	/**线路*/
	public final String TABLE_LINESN="table_linesn";
	public  final String LINESN_ID = "_id";	
	public  final String LINESN_NAME = "_name";	
	public  final String LINESN_CN_NAME = "cn_name";
	public  final String LINESN_JSON = "json";
	/**推荐事由*/
	public final String TABLE_TAGMSG="table_tagmsg";
	public  final String TAG_ID = "_id";	
	public  final String TAG_NAME = "_name";	
}
